package com.hxzy.research.mapper;

import com.hxzy.research.pojo.ShowCheck1;
import com.hxzy.research.pojo.ShowCheckQq;
import com.hxzy.research.pojo.TblCompResearch;

import java.util.List;

public interface TblCompResearchMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(TblCompResearch record);
    //添加综合满意度信息到tbl_comp_research
    public void AddCompResearch(TblCompResearch tblCompResearch) throws Exception;

    int insertSelective(TblCompResearch record);

    TblCompResearch selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TblCompResearch record);

    int updateByPrimaryKey(TblCompResearch record);
    //综合满意度调查结果查询-查询分公司
    public List<ShowCheck1> findR3ListByMonthAndBranchId(ShowCheckQq showCheckQq)throws Exception;
    //查看建议分公司-建议1，对公司的建议
    public List<String> findJy3_1List(ShowCheckQq showCheckQq)throws Exception;
    //查看建议分公司-建议2，对老师的建议
    public List<String> findJy3_2List(ShowCheckQq showCheckQq) throws Exception;

    //综合满意度调查结果-查询总体数据
    public List<ShowCheck1> findAllR3ListByMonth(String time)throws Exception;
    //查看建议总体数据-建议1，对公司的建议
    public List<String> findJy3_1AllList(ShowCheckQq showCheckQq)throws Exception;
    //查看建议总体数据-建议2，对老师的建议
    public List<String> findJy3_2AllList(ShowCheckQq showCheckQq) throws Exception;
}